﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="AuditLog.aspx.cs" Inherits="AuditLog" validateRequest=false  %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Log audit</title>
    <link href="/timereport/include/commoncss.aspx" rel="stylesheet" type="text/css" />
</head>
    <script language="JavaScript" src="/timereport/include/menu/menu_array.js" type="text/javascript"></script>
    <script language="JavaScript" src="/timereport/include/menu/mmenu.js" type="text/javascript"></script>
<body>

 <table width="760" border="0">
        <tr>
            <td height="30" class="BarraTop" align="right">Utente: <%= Session["UserName"] %>
            </td>
        </tr>
          <tr>
            <td height="30">&nbsp;</td>
           </tr>

    <tr><td>

    <form id="form1" runat="server">
    
    &nbsp;<asp:GridView 
        ID="GridView1" runat="server" AllowPaging="True" 
        AutoGenerateColumns="False" CssClass="GridView"
        DataSourceID="DSAudit" EnableModelValidation="True" AllowSorting="True" 
        EnableSortingAndPagingCallbacks="True" PageSize="15">
        <FooterStyle CssClass="GV_footer" />
        <RowStyle Wrap="False" CssClass="GV_row" />
        <PagerStyle CssClass="GV_footer" />
        <HeaderStyle CssClass="GV_header" />
        <AlternatingRowStyle CssClass="GV_row_alt " />
        <Columns>
            <asp:BoundField DataField="TYPE" HeaderText="TYPE" SortExpression="TYPE" />
            <asp:BoundField DataField="TableName" HeaderText="TableName" 
                SortExpression="TableName" />
            <asp:BoundField DataField="UpdateDate" HeaderText="UpdateDate" 
                SortExpression="UpdateDate" />
            <asp:BoundField DataField="PK" HeaderText="PK" SortExpression="PK" />
            <asp:BoundField DataField="FieldName" HeaderText="FieldName" 
                SortExpression="FieldName" />
            <asp:BoundField DataField="OldValue" HeaderText="OldValue" 
                SortExpression="OldValue" />
            <asp:BoundField DataField="NewValue" HeaderText="NewValue" 
                SortExpression="NewValue" />
        </Columns>
    </asp:GridView>
    
        <asp:SqlDataSource ID="DSAudit" runat="server" 
        ConnectionString="<%$ ConnectionStrings:MSSql12155ConnectionString %>" 
        SelectCommand="SELECT * FROM [Audit] WHERE (([PK] = @PK) AND ([TableName] = @TableName) AND ([TYPE] = @TYPE) )">
            <SelectParameters>
                <asp:QueryStringParameter Name="TYPE" QueryStringField="TYPE" Type="String" />
                <asp:QueryStringParameter Name="PK" QueryStringField="key" Type="String" />
                <asp:QueryStringParameter Name="TableName" QueryStringField="TableName" 
                    Type="String" />
            </SelectParameters>
    </asp:SqlDataSource>
    <br /><br /><br /><br />

    <table width="85%" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr>
        <td width="50%"> 

            <asp:Button ID="CancelButton" runat="server" CausesValidation="False" PostBackUrl="" Text="Annulla" CssClass="FormButton" />      

        </td>  
        </tr>
    </table>

    
        </form>        
</td></tr>    </table>

</body>
</html>
